<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
	<?php
		 $from='scl1203@163.com';
		 $subject=$_POST['subject'];
		 $text=$_POST['elvismail'];
		 
		 $dbc = mysqli_connect('localhost','root','root','elvis_store')
		 	or die('Error connection to MySQL server.');
		 	
		 $query ="select * from email_list where last_name = '$subject'";
		 $result = mysqli_query($dbc,$query)
		 	or die('Error querying database.');
		 	
		 while($row = mysqli_fetch_array($result)){
		 	$to=$row['email'];
		 	$first_name=$row['first_name'];
		 	$last_name=$row['last_name'];
		 	
		 	echo $to .' '.$first_name .' '.$last_name .' '. $text .'<br/>';
		 /*	$msg="Dear $first_name $last_name,\n$text";
		 	mail($to, $subject, $msg,'From:' . $from);
		 	echo 'Email sent to:'.$to.'<br/>';
		 
		 */
		 }
		 
		 mysqli_close($dbc);
		 	
		 
	?>
</body>
</html>